package com.aring.dao;

import java.util.ArrayList;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.aring.bean.MatchInfo;
import com.aring.bean.Place;
import com.aring.bean.PlaceManager;
import com.aring.bean.School;
import com.aring.bean.TimeTable;

public interface PlaceManagerDao {
	public int insertPlaceManager(PlaceManager placeManager);
	public PlaceManager selectPlaceManagerByAccount(String account);
	public int insertMatchInfo(MatchInfo mi);
	public PlaceManager selectPlaceManagerByPm_no(Integer pm_no);
	public int updateManager(PlaceManager placeManager);
	public ArrayList<PlaceManager> selectMatchInfo(Integer pm_no);
	public MatchInfo selectMatchByMi_no(Integer mi_no);
	public int updateMatch(MatchInfo match);
	public int insertPlace(Place place);
	public Place selectPlaceByP_no(Integer p_no);
	public ArrayList<Place> selectPlaceByPm_no(Integer pm_no);
	public int updatePlace(Place place);
	public ArrayList<School> querySchool(Integer pm_no);
	public ArrayList queryType(@Param(value="pm_no")Integer pm_no, @Param(value="school")Integer school);
	public School querySchoolById(Integer id);
	public Integer queryP_noBySchoolAndType(@Param(value="name")String name, @Param(value="type")String type);
	public int insertPlaceNum(@Param(value="p_no")Integer p_no, @Param(value="pn_no")Integer num);
	public Integer queryPn_id(@Param(value="p_no")Integer p_no,  @Param(value="pn_no")Integer pn_no);
	public int insertTimeTable(TimeTable table);

	

}
